/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package queenb.web.permission.store;
import java.sql.SQLException;
import java.util.List;
import oracle.jdbc.OracleTypes;
import queenb.net.datacontrol.DataStatement;
import queenb.net.datacontrol.Param;
import queenb.net.entitybean.Q150;
import queenb.web.util.PackageContants;
/**
 *
 * @author truong
 */
public class Q150Store extends Q150{





      public List<Q150> findQ175(int pnFH000,int pnFQ300, int pnFQ400, int FN100) throws SQLException, InstantiationException, IllegalAccessException {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_Q175, OracleTypes.CURSOR, new Param[]{
                                                        new Param(OracleTypes.INTEGER, pnFH000),
                                                        new Param(OracleTypes.INTEGER, pnFQ300),
                                                        new Param(OracleTypes.INTEGER, pnFQ400),
                                                        new Param(OracleTypes.INTEGER, FN100)
        });
        return super.find(dataStatement, Q150.class);
    }
     public List<Q150> findQ150L(int pnFH000,int pnFQ350, String pvLogin) throws SQLException, InstantiationException, IllegalAccessException {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_Q150L, OracleTypes.CURSOR, new Param[]{
                                                        new Param(OracleTypes.INTEGER, pnFH000),
                                                        new Param(OracleTypes.INTEGER, pnFQ350),
                                                        new Param(OracleTypes.CHAR, pvLogin)
        });
        return super.find(dataStatement, Q150.class);
    }

    public List<Q150> findQ150R(int pnFH000,int pnFQ350,String pvLogin) throws SQLException, InstantiationException, IllegalAccessException {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_Q150R, OracleTypes.CURSOR, new Param[]{
                                                        new Param(OracleTypes.INTEGER, pnFH000),
                                                        new Param(OracleTypes.INTEGER, pnFQ350),
                                                        new Param(OracleTypes.CHAR, pvLogin)
        });
        return super.find(dataStatement, Q150.class);
    }


    public int deleteQ150(int pnFH000,int pnFQ350,int pnFQ400,String pvLOGIN) throws SQLException, InstantiationException, IllegalAccessException {
        DataStatement dataStatement = new DataStatement(PackageContants.DELETE_Q150, OracleTypes.INTEGER, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFQ350),
                    new Param(OracleTypes.INTEGER, pnFQ400),
                    new Param(OracleTypes.CHAR, pvLOGIN)
                });
        return update(dataStatement, Q150.class);
    }

    public int updateQ150(int pnFH000,int pnFQ350,int pnFQ400 ,String pvLOGIN) throws SQLException {
        DataStatement updateQ150Statement = new DataStatement(PackageContants.UPDATE_Q150, OracleTypes.INTEGER, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFQ350),
                    new Param(OracleTypes.INTEGER, pnFQ400),
                    new Param(OracleTypes.CHAR, pvLOGIN)}
                    );
        return super.update(updateQ150Statement, null);
    }
 public List<Q150> findQ150N(int pnFH000, int pnFQ350, String pvLogin) throws SQLException, InstantiationException, IllegalAccessException {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_Q150N, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFQ350),
                    new Param(OracleTypes.CHAR, pvLogin)
                });
        return super.find(dataStatement, Q150.class);
    }
  public List<Q150> findQ150D(int pnFH000, int pnFQ300,int pnFQ350, String pvLogin) throws SQLException, InstantiationException, IllegalAccessException {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_Q150D, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                      new Param(OracleTypes.INTEGER, pnFQ300),
                    new Param(OracleTypes.INTEGER, pnFQ350),
                    new Param(OracleTypes.CHAR, pvLogin)
                });
        return super.find(dataStatement, Q150.class);
    }

}
